Show All
Find links in a workbook
There is no automatic way to find links used in a workbook. However, because links use brackets [ ] to enclose the source workbook name when it is closed, you can search for it. For example =SUM([Budget.xls]Annual!C10:C25).
- Close all workbooks except the one you want to find the links in.
- On the Edit menu, click Find.
- Click Options.
- In the Find what box, enter [.
- In the Within box, click Workbook.
- In the Look In box, click Formulas.
- Click Find All.
- In the box at the bottom, look in the Formula column for formulas that contain [.
- To select the cell with a link, select the row in the box at the bottom.
- Links are also commonly used in names, text boxes, or chart titles.
Find links used in names
- On the Insert menu, point to Name, and then click Define.
- Select each entry in the Names in workbook list, and look in the Refers to box for links. Links contain a reference to another workbook, such as [Budget.xls].
Find links used in text boxes or chart titles
- Click the text box or chart title you want to check.
- In the formula bar
, look for a reference to another workbook, such as [Budget.xls].
Find links used in other objects
- On the Edit menu, click Go To, and then click Special.
- Click Objects, and then click OK.
- Press TAB, and then look in the formula bar
for a reference to another workbook, such as [Budget.xls]. The name of the object appears in the Name box.
- Repeat the previous step until each object is checked.
Find links used in chart data series
- Select the data series you want to check.
- In the formula bar
, look for a reference to another workbook, such as [Budget.xls].
- To proceed to the next data series, press TAB.
- Repeat the previous two steps until each data series is checked.